using System; 
using System.Text; 
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration; 
using System.Xml; 
using System.Xml.Serialization;
using SubSonic; 
using SubSonic.Utilities;

namespace Adex{
    /// <summary>
    /// Strongly-typed collection for the VNewsLog class.
    /// </summary>
    [Serializable]
    public partial class VNewsLogCollection : ReadOnlyList<VNewsLog, VNewsLogCollection>
    {        
        public VNewsLogCollection() {}

    }

    /// <summary>
    /// This is  Read-only wrapper class for the vNewsLog view.
    /// </summary>
    [Serializable]
    public partial class VNewsLog : ReadOnlyRecord<VNewsLog> 
    {
    
	    #region Default Settings
	    protected static void SetSQLProps() 
	    {
		    GetTableSchema();
	    }

	    #endregion
        #region Schema Accessor
	    public static TableSchema.Table Schema
        {
            get
            {
                if (BaseSchema == null)
                {
                    SetSQLProps();
                }

                return BaseSchema;
            }

        }

    	
        private static void GetTableSchema() 
        {
            if(!IsSchemaInitialized)
            {
                //Schema declaration
                TableSchema.Table schema = new TableSchema.Table("vNewsLog", TableType.View, DataService.GetInstance("Adex"));
                schema.Columns = new TableSchema.TableColumnCollection();
                schema.SchemaName = "dbo";
                //columns
                
                TableSchema.TableColumn colvarNewsLogID = new TableSchema.TableColumn(schema);
                colvarNewsLogID.ColumnName = "NewsLogID";
                colvarNewsLogID.DataType = DbType.Int32;
                colvarNewsLogID.MaxLength = 0;
                colvarNewsLogID.AutoIncrement = false;
                colvarNewsLogID.IsNullable = false;
                colvarNewsLogID.IsPrimaryKey = false;
                colvarNewsLogID.IsForeignKey = false;
                colvarNewsLogID.IsReadOnly = false;
                
                schema.Columns.Add(colvarNewsLogID);
                
                TableSchema.TableColumn colvarCountryID = new TableSchema.TableColumn(schema);
                colvarCountryID.ColumnName = "CountryID";
                colvarCountryID.DataType = DbType.Byte;
                colvarCountryID.MaxLength = 0;
                colvarCountryID.AutoIncrement = false;
                colvarCountryID.IsNullable = true;
                colvarCountryID.IsPrimaryKey = false;
                colvarCountryID.IsForeignKey = false;
                colvarCountryID.IsReadOnly = false;
                
                schema.Columns.Add(colvarCountryID);
                
                TableSchema.TableColumn colvarRFDate = new TableSchema.TableColumn(schema);
                colvarRFDate.ColumnName = "RFDate";
                colvarRFDate.DataType = DbType.DateTime;
                colvarRFDate.MaxLength = 0;
                colvarRFDate.AutoIncrement = false;
                colvarRFDate.IsNullable = false;
                colvarRFDate.IsPrimaryKey = false;
                colvarRFDate.IsForeignKey = false;
                colvarRFDate.IsReadOnly = false;
                
                schema.Columns.Add(colvarRFDate);
                
                TableSchema.TableColumn colvarMediaType = new TableSchema.TableColumn(schema);
                colvarMediaType.ColumnName = "MediaTypeCode";
                colvarMediaType.DataType = DbType.Byte;
                colvarMediaType.MaxLength = 0;
                colvarMediaType.AutoIncrement = false;
                colvarMediaType.IsNullable = true;
                colvarMediaType.IsPrimaryKey = false;
                colvarMediaType.IsForeignKey = false;
                colvarMediaType.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaType);
                
                TableSchema.TableColumn colvarMediaCode = new TableSchema.TableColumn(schema);
                colvarMediaCode.ColumnName = "MediaCode";
                colvarMediaCode.DataType = DbType.Int32;
                colvarMediaCode.MaxLength = 0;
                colvarMediaCode.AutoIncrement = false;
                colvarMediaCode.IsNullable = true;
                colvarMediaCode.IsPrimaryKey = false;
                colvarMediaCode.IsForeignKey = false;
                colvarMediaCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaCode);
                
                TableSchema.TableColumn colvarNewsTitle = new TableSchema.TableColumn(schema);
                colvarNewsTitle.ColumnName = "NewsTitle";
                colvarNewsTitle.DataType = DbType.String;
                colvarNewsTitle.MaxLength = 300;
                colvarNewsTitle.AutoIncrement = false;
                colvarNewsTitle.IsNullable = true;
                colvarNewsTitle.IsPrimaryKey = false;
                colvarNewsTitle.IsForeignKey = false;
                colvarNewsTitle.IsReadOnly = false;
                
                schema.Columns.Add(colvarNewsTitle);
                
                TableSchema.TableColumn colvarNewsType = new TableSchema.TableColumn(schema);
                colvarNewsType.ColumnName = "NewsTypeCode";
                colvarNewsType.DataType = DbType.Byte;
                colvarNewsType.MaxLength = 0;
                colvarNewsType.AutoIncrement = false;
                colvarNewsType.IsNullable = true;
                colvarNewsType.IsPrimaryKey = false;
                colvarNewsType.IsForeignKey = false;
                colvarNewsType.IsReadOnly = false;
                
                schema.Columns.Add(colvarNewsType);
                
                TableSchema.TableColumn colvarNewsTypeName = new TableSchema.TableColumn(schema);
                colvarNewsTypeName.ColumnName = "NewsTypeName";
                colvarNewsTypeName.DataType = DbType.String;
                colvarNewsTypeName.MaxLength = 100;
                colvarNewsTypeName.AutoIncrement = false;
                colvarNewsTypeName.IsNullable = true;
                colvarNewsTypeName.IsPrimaryKey = false;
                colvarNewsTypeName.IsForeignKey = false;
                colvarNewsTypeName.IsReadOnly = false;
                
                schema.Columns.Add(colvarNewsTypeName);
                
                TableSchema.TableColumn colvarPageNumber = new TableSchema.TableColumn(schema);
                colvarPageNumber.ColumnName = "PageNumber";
                colvarPageNumber.DataType = DbType.Int32;
                colvarPageNumber.MaxLength = 0;
                colvarPageNumber.AutoIncrement = false;
                colvarPageNumber.IsNullable = true;
                colvarPageNumber.IsPrimaryKey = false;
                colvarPageNumber.IsForeignKey = false;
                colvarPageNumber.IsReadOnly = false;
                
                schema.Columns.Add(colvarPageNumber);
                
                TableSchema.TableColumn colvarColumnSize = new TableSchema.TableColumn(schema);
                colvarColumnSize.ColumnName = "ColumnSize";
                colvarColumnSize.DataType = DbType.Int32;
                colvarColumnSize.MaxLength = 0;
                colvarColumnSize.AutoIncrement = false;
                colvarColumnSize.IsNullable = true;
                colvarColumnSize.IsPrimaryKey = false;
                colvarColumnSize.IsForeignKey = false;
                colvarColumnSize.IsReadOnly = false;
                
                schema.Columns.Add(colvarColumnSize);
                
                TableSchema.TableColumn colvarInchesSize = new TableSchema.TableColumn(schema);
                colvarInchesSize.ColumnName = "InchesSize";
                colvarInchesSize.DataType = DbType.Int32;
                colvarInchesSize.MaxLength = 0;
                colvarInchesSize.AutoIncrement = false;
                colvarInchesSize.IsNullable = true;
                colvarInchesSize.IsPrimaryKey = false;
                colvarInchesSize.IsForeignKey = false;
                colvarInchesSize.IsReadOnly = false;
                
                schema.Columns.Add(colvarInchesSize);
                
                TableSchema.TableColumn colvarRealCost = new TableSchema.TableColumn(schema);
                colvarRealCost.ColumnName = "RealCost";
                colvarRealCost.DataType = DbType.Currency;
                colvarRealCost.MaxLength = 0;
                colvarRealCost.AutoIncrement = false;
                colvarRealCost.IsNullable = true;
                colvarRealCost.IsPrimaryKey = false;
                colvarRealCost.IsForeignKey = false;
                colvarRealCost.IsReadOnly = false;
                
                schema.Columns.Add(colvarRealCost);
                
                TableSchema.TableColumn colvarSectionCode = new TableSchema.TableColumn(schema);
                colvarSectionCode.ColumnName = "SectionCode";
                colvarSectionCode.DataType = DbType.Int32;
                colvarSectionCode.MaxLength = 0;
                colvarSectionCode.AutoIncrement = false;
                colvarSectionCode.IsNullable = true;
                colvarSectionCode.IsPrimaryKey = false;
                colvarSectionCode.IsForeignKey = false;
                colvarSectionCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarSectionCode);
                
                TableSchema.TableColumn colvarProductID = new TableSchema.TableColumn(schema);
                colvarProductID.ColumnName = "ProductID";
                colvarProductID.DataType = DbType.Int32;
                colvarProductID.MaxLength = 0;
                colvarProductID.AutoIncrement = false;
                colvarProductID.IsNullable = true;
                colvarProductID.IsPrimaryKey = false;
                colvarProductID.IsForeignKey = false;
                colvarProductID.IsReadOnly = false;
                
                schema.Columns.Add(colvarProductID);
                
                TableSchema.TableColumn colvarCategoryID = new TableSchema.TableColumn(schema);
                colvarCategoryID.ColumnName = "CategoryID";
                colvarCategoryID.DataType = DbType.Int32;
                colvarCategoryID.MaxLength = 0;
                colvarCategoryID.AutoIncrement = false;
                colvarCategoryID.IsNullable = true;
                colvarCategoryID.IsPrimaryKey = false;
                colvarCategoryID.IsForeignKey = false;
                colvarCategoryID.IsReadOnly = false;
                
                schema.Columns.Add(colvarCategoryID);
                
                TableSchema.TableColumn colvarSubSectorID = new TableSchema.TableColumn(schema);
                colvarSubSectorID.ColumnName = "SubSectorID";
                colvarSubSectorID.DataType = DbType.Int32;
                colvarSubSectorID.MaxLength = 0;
                colvarSubSectorID.AutoIncrement = false;
                colvarSubSectorID.IsNullable = true;
                colvarSubSectorID.IsPrimaryKey = false;
                colvarSubSectorID.IsForeignKey = false;
                colvarSubSectorID.IsReadOnly = false;
                
                schema.Columns.Add(colvarSubSectorID);
                
                TableSchema.TableColumn colvarSectorID = new TableSchema.TableColumn(schema);
                colvarSectorID.ColumnName = "SectorID";
                colvarSectorID.DataType = DbType.Int32;
                colvarSectorID.MaxLength = 0;
                colvarSectorID.AutoIncrement = false;
                colvarSectorID.IsNullable = true;
                colvarSectorID.IsPrimaryKey = false;
                colvarSectorID.IsForeignKey = false;
                colvarSectorID.IsReadOnly = false;
                
                schema.Columns.Add(colvarSectorID);
                
                TableSchema.TableColumn colvarNewsLink = new TableSchema.TableColumn(schema);
                colvarNewsLink.ColumnName = "NewsLink";
                colvarNewsLink.DataType = DbType.String;
                colvarNewsLink.MaxLength = 300;
                colvarNewsLink.AutoIncrement = false;
                colvarNewsLink.IsNullable = true;
                colvarNewsLink.IsPrimaryKey = false;
                colvarNewsLink.IsForeignKey = false;
                colvarNewsLink.IsReadOnly = false;
                
                schema.Columns.Add(colvarNewsLink);
                
                TableSchema.TableColumn colvarNewsMediaType = new TableSchema.TableColumn(schema);
                colvarNewsMediaType.ColumnName = "NewsMediaType";
                colvarNewsMediaType.DataType = DbType.String;
                colvarNewsMediaType.MaxLength = 100;
                colvarNewsMediaType.AutoIncrement = false;
                colvarNewsMediaType.IsNullable = true;
                colvarNewsMediaType.IsPrimaryKey = false;
                colvarNewsMediaType.IsForeignKey = false;
                colvarNewsMediaType.IsReadOnly = false;
                
                schema.Columns.Add(colvarNewsMediaType);
                
                TableSchema.TableColumn colvarCropPicture = new TableSchema.TableColumn(schema);
                colvarCropPicture.ColumnName = "CropPicture";
                colvarCropPicture.DataType = DbType.String;
                colvarCropPicture.MaxLength = 50;
                colvarCropPicture.AutoIncrement = false;
                colvarCropPicture.IsNullable = true;
                colvarCropPicture.IsPrimaryKey = false;
                colvarCropPicture.IsForeignKey = false;
                colvarCropPicture.IsReadOnly = false;
                
                schema.Columns.Add(colvarCropPicture);
                
                TableSchema.TableColumn colvarFullPagePicture = new TableSchema.TableColumn(schema);
                colvarFullPagePicture.ColumnName = "FullPagePicture";
                colvarFullPagePicture.DataType = DbType.String;
                colvarFullPagePicture.MaxLength = 50;
                colvarFullPagePicture.AutoIncrement = false;
                colvarFullPagePicture.IsNullable = true;
                colvarFullPagePicture.IsPrimaryKey = false;
                colvarFullPagePicture.IsForeignKey = false;
                colvarFullPagePicture.IsReadOnly = false;
                
                schema.Columns.Add(colvarFullPagePicture);
                
                TableSchema.TableColumn colvarPDFName = new TableSchema.TableColumn(schema);
                colvarPDFName.ColumnName = "PDFName";
                colvarPDFName.DataType = DbType.String;
                colvarPDFName.MaxLength = 50;
                colvarPDFName.AutoIncrement = false;
                colvarPDFName.IsNullable = true;
                colvarPDFName.IsPrimaryKey = false;
                colvarPDFName.IsForeignKey = false;
                colvarPDFName.IsReadOnly = false;
                
                schema.Columns.Add(colvarPDFName);
                
                TableSchema.TableColumn colvarDateAdded = new TableSchema.TableColumn(schema);
                colvarDateAdded.ColumnName = "DateAdded";
                colvarDateAdded.DataType = DbType.DateTime;
                colvarDateAdded.MaxLength = 0;
                colvarDateAdded.AutoIncrement = false;
                colvarDateAdded.IsNullable = false;
                colvarDateAdded.IsPrimaryKey = false;
                colvarDateAdded.IsForeignKey = false;
                colvarDateAdded.IsReadOnly = false;
                
                schema.Columns.Add(colvarDateAdded);
                
                TableSchema.TableColumn colvarDateModified = new TableSchema.TableColumn(schema);
                colvarDateModified.ColumnName = "DateModified";
                colvarDateModified.DataType = DbType.DateTime;
                colvarDateModified.MaxLength = 0;
                colvarDateModified.AutoIncrement = false;
                colvarDateModified.IsNullable = false;
                colvarDateModified.IsPrimaryKey = false;
                colvarDateModified.IsForeignKey = false;
                colvarDateModified.IsReadOnly = false;
                
                schema.Columns.Add(colvarDateModified);
                
                TableSchema.TableColumn colvarSectorCode = new TableSchema.TableColumn(schema);
                colvarSectorCode.ColumnName = "SectorCode";
                colvarSectorCode.DataType = DbType.Int32;
                colvarSectorCode.MaxLength = 0;
                colvarSectorCode.AutoIncrement = false;
                colvarSectorCode.IsNullable = true;
                colvarSectorCode.IsPrimaryKey = false;
                colvarSectorCode.IsForeignKey = false;
                colvarSectorCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarSectorCode);
                
                TableSchema.TableColumn colvarSectorName = new TableSchema.TableColumn(schema);
                colvarSectorName.ColumnName = "SectorName";
                colvarSectorName.DataType = DbType.String;
                colvarSectorName.MaxLength = 500;
                colvarSectorName.AutoIncrement = false;
                colvarSectorName.IsNullable = true;
                colvarSectorName.IsPrimaryKey = false;
                colvarSectorName.IsForeignKey = false;
                colvarSectorName.IsReadOnly = false;
                
                schema.Columns.Add(colvarSectorName);
                
                TableSchema.TableColumn colvarSubSectorCode = new TableSchema.TableColumn(schema);
                colvarSubSectorCode.ColumnName = "SubSectorCode";
                colvarSubSectorCode.DataType = DbType.Int32;
                colvarSubSectorCode.MaxLength = 0;
                colvarSubSectorCode.AutoIncrement = false;
                colvarSubSectorCode.IsNullable = true;
                colvarSubSectorCode.IsPrimaryKey = false;
                colvarSubSectorCode.IsForeignKey = false;
                colvarSubSectorCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarSubSectorCode);
                
                TableSchema.TableColumn colvarSubSectorName = new TableSchema.TableColumn(schema);
                colvarSubSectorName.ColumnName = "SubSectorName";
                colvarSubSectorName.DataType = DbType.String;
                colvarSubSectorName.MaxLength = 500;
                colvarSubSectorName.AutoIncrement = false;
                colvarSubSectorName.IsNullable = true;
                colvarSubSectorName.IsPrimaryKey = false;
                colvarSubSectorName.IsForeignKey = false;
                colvarSubSectorName.IsReadOnly = false;
                
                schema.Columns.Add(colvarSubSectorName);
                
                TableSchema.TableColumn colvarMediaName = new TableSchema.TableColumn(schema);
                colvarMediaName.ColumnName = "MediaName";
                colvarMediaName.DataType = DbType.String;
                colvarMediaName.MaxLength = 255;
                colvarMediaName.AutoIncrement = false;
                colvarMediaName.IsNullable = true;
                colvarMediaName.IsPrimaryKey = false;
                colvarMediaName.IsForeignKey = false;
                colvarMediaName.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaName);
                
                TableSchema.TableColumn colvarMediaTypeName = new TableSchema.TableColumn(schema);
                colvarMediaTypeName.ColumnName = "MediaTypeName";
                colvarMediaTypeName.DataType = DbType.String;
                colvarMediaTypeName.MaxLength = 50;
                colvarMediaTypeName.AutoIncrement = false;
                colvarMediaTypeName.IsNullable = true;
                colvarMediaTypeName.IsPrimaryKey = false;
                colvarMediaTypeName.IsForeignKey = false;
                colvarMediaTypeName.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaTypeName);
                
                TableSchema.TableColumn colvarCategoryCode = new TableSchema.TableColumn(schema);
                colvarCategoryCode.ColumnName = "CategoryCode";
                colvarCategoryCode.DataType = DbType.Int32;
                colvarCategoryCode.MaxLength = 0;
                colvarCategoryCode.AutoIncrement = false;
                colvarCategoryCode.IsNullable = true;
                colvarCategoryCode.IsPrimaryKey = false;
                colvarCategoryCode.IsForeignKey = false;
                colvarCategoryCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarCategoryCode);
                
                TableSchema.TableColumn colvarCategoryName = new TableSchema.TableColumn(schema);
                colvarCategoryName.ColumnName = "CategoryName";
                colvarCategoryName.DataType = DbType.String;
                colvarCategoryName.MaxLength = 255;
                colvarCategoryName.AutoIncrement = false;
                colvarCategoryName.IsNullable = true;
                colvarCategoryName.IsPrimaryKey = false;
                colvarCategoryName.IsForeignKey = false;
                colvarCategoryName.IsReadOnly = false;
                
                schema.Columns.Add(colvarCategoryName);
                
                TableSchema.TableColumn colvarSectionName = new TableSchema.TableColumn(schema);
                colvarSectionName.ColumnName = "SectionName";
                colvarSectionName.DataType = DbType.String;
                colvarSectionName.MaxLength = 300;
                colvarSectionName.AutoIncrement = false;
                colvarSectionName.IsNullable = true;
                colvarSectionName.IsPrimaryKey = false;
                colvarSectionName.IsForeignKey = false;
                colvarSectionName.IsReadOnly = false;
                
                schema.Columns.Add(colvarSectionName);
                
                TableSchema.TableColumn colvarProductCode = new TableSchema.TableColumn(schema);
                colvarProductCode.ColumnName = "ProductCode";
                colvarProductCode.DataType = DbType.Int32;
                colvarProductCode.MaxLength = 0;
                colvarProductCode.AutoIncrement = false;
                colvarProductCode.IsNullable = true;
                colvarProductCode.IsPrimaryKey = false;
                colvarProductCode.IsForeignKey = false;
                colvarProductCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarProductCode);
                
                TableSchema.TableColumn colvarProductName = new TableSchema.TableColumn(schema);
                colvarProductName.ColumnName = "ProductName";
                colvarProductName.DataType = DbType.String;
                colvarProductName.MaxLength = 255;
                colvarProductName.AutoIncrement = false;
                colvarProductName.IsNullable = true;
                colvarProductName.IsPrimaryKey = false;
                colvarProductName.IsForeignKey = false;
                colvarProductName.IsReadOnly = false;
                
                schema.Columns.Add(colvarProductName);
                
                
                BaseSchema = schema;
                //add this schema to the provider
                //so we can query it later
                DataService.Providers["Adex"].AddSchema("vNewsLog",schema);
            }

        }

        #endregion
        
        #region Query Accessor
	    public static Query CreateQuery()
	    {
		    return new Query(Schema);
	    }

	    #endregion
	    
	    #region .ctors
	    public VNewsLog()
	    {
            SetSQLProps();
            SetDefaults();
            MarkNew();
        }

        public VNewsLog(bool useDatabaseDefaults)
	    {
		    SetSQLProps();
		    if(useDatabaseDefaults)
		    {
				ForceDefaults();
			}

			MarkNew();
	    }

	    
	    public VNewsLog(object keyID)
	    {
		    SetSQLProps();
		    LoadByKey(keyID);
	    }

    	 
	    public VNewsLog(string columnName, object columnValue)
        {
            SetSQLProps();
            LoadByParam(columnName,columnValue);
        }

        
	    #endregion
	    
	    #region Props
	    
          
        [XmlAttribute("NewsLogID")]
        public int NewsLogID 
	    {
		    get
		    {
			    return GetColumnValue<int>("NewsLogID");
		    }

            set 
		    {
			    SetColumnValue("NewsLogID", value);
            }

        }

	      
        [XmlAttribute("CountryID")]
        public byte? CountryID 
	    {
		    get
		    {
			    return GetColumnValue<byte?>("CountryID");
		    }

            set 
		    {
			    SetColumnValue("CountryID", value);
            }

        }

	      
        [XmlAttribute("RFDate")]
        public DateTime RFDate 
	    {
		    get
		    {
			    return GetColumnValue<DateTime>("RFDate");
		    }

            set 
		    {
			    SetColumnValue("RFDate", value);
            }

        }

	      
        [XmlAttribute("MediaType")]
        public byte? MediaType 
	    {
		    get
		    {
			    return GetColumnValue<byte?>("MediaTypeCode");
		    }

            set 
		    {
			    SetColumnValue("MediaTypeCode", value);
            }

        }

	      
        [XmlAttribute("MediaCode")]
        public int? MediaCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("MediaCode");
		    }

            set 
		    {
			    SetColumnValue("MediaCode", value);
            }

        }

	      
        [XmlAttribute("NewsTitle")]
        public string NewsTitle 
	    {
		    get
		    {
			    return GetColumnValue<string>("NewsTitle");
		    }

            set 
		    {
			    SetColumnValue("NewsTitle", value);
            }

        }

	      
        [XmlAttribute("NewsType")]
        public byte? NewsType 
	    {
		    get
		    {
			    return GetColumnValue<byte?>("NewsTypeCode");
		    }

            set 
		    {
			    SetColumnValue("NewsTypeCode", value);
            }

        }

	      
        [XmlAttribute("NewsTypeName")]
        public string NewsTypeName 
	    {
		    get
		    {
			    return GetColumnValue<string>("NewsTypeName");
		    }

            set 
		    {
			    SetColumnValue("NewsTypeName", value);
            }

        }

	      
        [XmlAttribute("PageNumber")]
        public int? PageNumber 
	    {
		    get
		    {
			    return GetColumnValue<int?>("PageNumber");
		    }

            set 
		    {
			    SetColumnValue("PageNumber", value);
            }

        }

	      
        [XmlAttribute("ColumnSize")]
        public int? ColumnSize 
	    {
		    get
		    {
			    return GetColumnValue<int?>("ColumnSize");
		    }

            set 
		    {
			    SetColumnValue("ColumnSize", value);
            }

        }

	      
        [XmlAttribute("InchesSize")]
        public int? InchesSize 
	    {
		    get
		    {
			    return GetColumnValue<int?>("InchesSize");
		    }

            set 
		    {
			    SetColumnValue("InchesSize", value);
            }

        }

	      
        [XmlAttribute("RealCost")]
        public decimal? RealCost 
	    {
		    get
		    {
			    return GetColumnValue<decimal?>("RealCost");
		    }

            set 
		    {
			    SetColumnValue("RealCost", value);
            }

        }

	      
        [XmlAttribute("SectionCode")]
        public int? SectionCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("SectionCode");
		    }

            set 
		    {
			    SetColumnValue("SectionCode", value);
            }

        }

	      
        [XmlAttribute("ProductID")]
        public int? ProductID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("ProductID");
		    }

            set 
		    {
			    SetColumnValue("ProductID", value);
            }

        }

	      
        [XmlAttribute("CategoryID")]
        public int? CategoryID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("CategoryID");
		    }

            set 
		    {
			    SetColumnValue("CategoryID", value);
            }

        }

	      
        [XmlAttribute("SubSectorID")]
        public int? SubSectorID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("SubSectorID");
		    }

            set 
		    {
			    SetColumnValue("SubSectorID", value);
            }

        }

	      
        [XmlAttribute("SectorID")]
        public int? SectorID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("SectorID");
		    }

            set 
		    {
			    SetColumnValue("SectorID", value);
            }

        }

	      
        [XmlAttribute("NewsLink")]
        public string NewsLink 
	    {
		    get
		    {
			    return GetColumnValue<string>("NewsLink");
		    }

            set 
		    {
			    SetColumnValue("NewsLink", value);
            }

        }

	      
        [XmlAttribute("NewsMediaType")]
        public string NewsMediaType 
	    {
		    get
		    {
			    return GetColumnValue<string>("NewsMediaType");
		    }

            set 
		    {
			    SetColumnValue("NewsMediaType", value);
            }

        }

	      
        [XmlAttribute("CropPicture")]
        public string CropPicture 
	    {
		    get
		    {
			    return GetColumnValue<string>("CropPicture");
		    }

            set 
		    {
			    SetColumnValue("CropPicture", value);
            }

        }

	      
        [XmlAttribute("FullPagePicture")]
        public string FullPagePicture 
	    {
		    get
		    {
			    return GetColumnValue<string>("FullPagePicture");
		    }

            set 
		    {
			    SetColumnValue("FullPagePicture", value);
            }

        }

	      
        [XmlAttribute("PDFName")]
        public string PDFName 
	    {
		    get
		    {
			    return GetColumnValue<string>("PDFName");
		    }

            set 
		    {
			    SetColumnValue("PDFName", value);
            }

        }

	      
        [XmlAttribute("DateAdded")]
        public DateTime DateAdded 
	    {
		    get
		    {
			    return GetColumnValue<DateTime>("DateAdded");
		    }

            set 
		    {
			    SetColumnValue("DateAdded", value);
            }

        }

	      
        [XmlAttribute("DateModified")]
        public DateTime DateModified 
	    {
		    get
		    {
			    return GetColumnValue<DateTime>("DateModified");
		    }

            set 
		    {
			    SetColumnValue("DateModified", value);
            }

        }

	      
        [XmlAttribute("SectorCode")]
        public int? SectorCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("SectorCode");
		    }

            set 
		    {
			    SetColumnValue("SectorCode", value);
            }

        }

	      
        [XmlAttribute("SectorName")]
        public string SectorName 
	    {
		    get
		    {
			    return GetColumnValue<string>("SectorName");
		    }

            set 
		    {
			    SetColumnValue("SectorName", value);
            }

        }

	      
        [XmlAttribute("SubSectorCode")]
        public int? SubSectorCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("SubSectorCode");
		    }

            set 
		    {
			    SetColumnValue("SubSectorCode", value);
            }

        }

	      
        [XmlAttribute("SubSectorName")]
        public string SubSectorName 
	    {
		    get
		    {
			    return GetColumnValue<string>("SubSectorName");
		    }

            set 
		    {
			    SetColumnValue("SubSectorName", value);
            }

        }

	      
        [XmlAttribute("MediaName")]
        public string MediaName 
	    {
		    get
		    {
			    return GetColumnValue<string>("MediaName");
		    }

            set 
		    {
			    SetColumnValue("MediaName", value);
            }

        }

	      
        [XmlAttribute("MediaTypeName")]
        public string MediaTypeName 
	    {
		    get
		    {
			    return GetColumnValue<string>("MediaTypeName");
		    }

            set 
		    {
			    SetColumnValue("MediaTypeName", value);
            }

        }

	      
        [XmlAttribute("CategoryCode")]
        public int? CategoryCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("CategoryCode");
		    }

            set 
		    {
			    SetColumnValue("CategoryCode", value);
            }

        }

	      
        [XmlAttribute("CategoryName")]
        public string CategoryName 
	    {
		    get
		    {
			    return GetColumnValue<string>("CategoryName");
		    }

            set 
		    {
			    SetColumnValue("CategoryName", value);
            }

        }

	      
        [XmlAttribute("SectionName")]
        public string SectionName 
	    {
		    get
		    {
			    return GetColumnValue<string>("SectionName");
		    }

            set 
		    {
			    SetColumnValue("SectionName", value);
            }

        }

	      
        [XmlAttribute("ProductCode")]
        public int? ProductCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("ProductCode");
		    }

            set 
		    {
			    SetColumnValue("ProductCode", value);
            }

        }

	      
        [XmlAttribute("ProductName")]
        public string ProductName 
	    {
		    get
		    {
			    return GetColumnValue<string>("ProductName");
		    }

            set 
		    {
			    SetColumnValue("ProductName", value);
            }

        }

	    
	    #endregion
    
	    #region Columns Struct
	    public struct Columns
	    {
		    
		    
            public static string NewsLogID = @"NewsLogID";
            
            public static string CountryID = @"CountryID";
            
            public static string RFDate = @"RFDate";
            
            public static string MediaType = @"MediaTypeCode";
            
            public static string MediaCode = @"MediaCode";
            
            public static string NewsTitle = @"NewsTitle";
            
            public static string NewsType = @"NewsTypeCode";
            
            public static string NewsTypeName = @"NewsTypeName";
            
            public static string PageNumber = @"PageNumber";
            
            public static string ColumnSize = @"ColumnSize";
            
            public static string InchesSize = @"InchesSize";
            
            public static string RealCost = @"RealCost";
            
            public static string SectionCode = @"SectionCode";
            
            public static string ProductID = @"ProductID";
            
            public static string CategoryID = @"CategoryID";
            
            public static string SubSectorID = @"SubSectorID";
            
            public static string SectorID = @"SectorID";
            
            public static string NewsLink = @"NewsLink";
            
            public static string NewsMediaType = @"NewsMediaType";
            
            public static string CropPicture = @"CropPicture";
            
            public static string FullPagePicture = @"FullPagePicture";
            
            public static string PDFName = @"PDFName";
            
            public static string DateAdded = @"DateAdded";
            
            public static string DateModified = @"DateModified";
            
            public static string SectorCode = @"SectorCode";
            
            public static string SectorName = @"SectorName";
            
            public static string SubSectorCode = @"SubSectorCode";
            
            public static string SubSectorName = @"SubSectorName";
            
            public static string MediaName = @"MediaName";
            
            public static string MediaTypeName = @"MediaTypeName";
            
            public static string CategoryCode = @"CategoryCode";
            
            public static string CategoryName = @"CategoryName";
            
            public static string SectionName = @"SectionName";
            
            public static string ProductCode = @"ProductCode";
            
            public static string ProductName = @"ProductName";
            
	    }

	    #endregion
    }

}

